Use SqlQueryActivity
Note: Use caution when building or editing a workflow. For further advice or to arrange training, contact your professional services consultant.
The SqlQueryActivity can be used to run a SQL (Structured Query Language) select statement that can be used to retrieve information from a database.
Note: Updating the database directly or with an activity is not advised.
The SqlQueryActivity is located in the Tribal Generic section of the Tribal Toolbox.
Note: The minimum requirement for the SqlQueryActivity is the Sql value.
This activity contains the following relevant properties:
Section | This field | Holds this information... |
---|---|---|
Misc | CommandTimeOut |
The time out value in seconds. Note: The CommandTimeOut property is set to 0 by default. |
ConnectionString | The parameters needed to establish a database connection (for example: the database name). | |
DataTable | The DataTable variable that will hold the dataset returned by the query. | |
DisplayName |
The title of the activity. Note: The DisplayName property is set to SqlQueryActivity by default |
|
Exception | The exception in the event of a failure. | |
Sql | The SQL statement that you want to run for all database types. |
Clicking the ellipsis button adjacent to the relevant field opens the Expression Editor where you can enter the relevant code in the Visual Basic (VB) format.